Computer Science Lesson Plan
Class: 6th to 8th, Lesson 2.2.1 : Application of Spreadsheet

Purpose: Students should learn the properties of cells in a spreadsheet.

No. of Classes

Depending upon the class strength and number of computers (Two classes for 20 students).

Material Required

Open office (Spreadsheet).

Curriculum Content
  • 3.3.1) Cell
  • 3.3.2) Row
  • 3.3.3) Column
  • 3.3.4) Sheet
  • 3.3.5) Insert new sheet
  • 3.3.6) Cell properties

    • Prior knowledge

    Students should know about Text documents clearly.

    Exercise

    Exercise:1


    1. Change the cell color of the following cells as specified:  D13 to Green, G18 to Red, and J7 to Violet.

    Exercise:2


    2. Add a new sheet after sheet 1 and change the sheet name.

    Exercise:3


    3. Find the cell addresses of the cells marked in the below screenshot:

    No Image

    Solution



    Teacher's Instruction
    1. Teachers should teach the basic operations by using a spreadsheet before giving any exercise.
    2. Teachers should ensure that the Students understand how to insert a new sheet, how to move the sheets before or after another sheet and also how to rename sheets
    3. Teachers can allow students to complete the exercise in a group.